﻿CREATE PROCEDURE [dbo].[AddTriggerInstnace]
(@WorkflowTriggerInstanceID varchar(50),
@TriggerComponentID varchar(50),
@WorkflowDesignID varchar(50),
@TriggerType int,
@TimeSpanUnit int,
@Interval int, 
@FirstStartTime datetime,
@LastRunTime datetime,
@NextRunTime datetime,
@IsActive bit) as 
begin
	insert into WorkflowTriggerInstance 
	(WorkflowTriggerInstanceID,
	TriggerComponentID,
	WorkflowDesignID,
	TriggerType,
	TimeSpanUnit,
	Interval,
	FirstStartTime,
	LastRunTime,
	NextRunTime,
	IsActive) values 
	(@WorkflowTriggerInstanceID,
	@TriggerComponentID,
	@WorkflowDesignID,
	@TriggerType,
	@TimeSpanUnit,
	@Interval,
	@FirstStartTime,
	@LastRunTime,
	@NextRunTime,
	@IsActive)
end


